Link wizard - File Structure

If the tables you are loading are related to one another in the new database, their relationships need to be defined in the Data Transformation file (or you can use the Link script file). Once the Control Script has been processed and all of the tables have been loaded, the link building process can begin.

When performing an update on a table, all links using that table will be destroyed automatically. The script ensures that the links are correctly rebuilt after the load event has occurred. If a link already exists, the declaration will be ignored.

The name of the Data Transformation file (or Link file if you prefer to use that) is defined in the configuration process. The script determines how the relational links are built between each table and takes the form of a list of fully qualified primary and foreign keys, in the following format:

[database].[table].[field1] = [database].[table].[field2]

In certain cases, it may be necessary to create an aggregate field to form one or both sides of the link. In this case, the LINK_KEY keyword will be used. This will be in the format:

LINK_KEY = Full Table Name, Short Name For Key,{Engine expression}

If the link process requires aggregate fields, these must be constructed at the start of the script, prior to the link process beginning.

• Data Engineering
  • Using The Data Transformation Wizard
  • Creating User Variables Within iLoader
  • Using The Link Wizard
  • Link Wizard - File Structure
  • LINK Examples
  • Data Transformation Commands
  • Data Transformation Examples